﻿CREATE TABLE [dbo].[ProductMaterials] (
    [ID]           INT          IDENTITY (1, 1) NOT NULL,
    [MaterialName] VARCHAR (20) NOT NULL,
    [MType]        TINYINT      CONSTRAINT [DF_ProductMaterials_MType] DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_ProductMaterial] PRIMARY KEY CLUSTERED ([ID] ASC)
);

